/**
 * 
 */
package com.apinoo.util.users;

/**
 * @author Alejandro Pino Oreamuno
 *
 */
public class Constants {
	
	/**
	 * GENERIC
	 */
	public static final String ALL									= "all";
	
	/**
	 * TABLES
	 */
	
	public static final String TABLE_GROUPS 						= "groups";
	public static final String TABLE_USERS 							= "users";
	public static final String TABLE_LOGINS 						= "logins";
	public static final String TABLE_EXCEPTIONS 					= "exceptions";
	
	/**
	 * TABLE FIELDS
	 */
	
	/* USERS **************************************************************/
	public static final String FIELD_USER_ID 						= "id_user";
	public static final String FIELD_USER_USERNAME					= "username";
	public static final String FIELD_USER_PASSWORD					= "password";
	public static final String FIELD_USER_EMAIL						= "email";
	public static final String FIELD_USER_CREATED 					= "created";
	public static final String FIELD_USER_ENABLED 					= "enabled";
	
	/* GROUPS *************************************************************/
	public static final String FIELD_GROUP_ID_GROUP 				= "id_group";
	public static final String FIELD_GROUP_NAME 					= "name";
	public static final String FIELD_GROUP_AUTHORITY 				= "authority";
	
	/* ORDER BY ***********************************************************/

	public static final String ORDER_BY_ID_USER_ASC					= "I";
	public static final String ORDER_BY_ID_USER_DESC				= "i";
	public static final String ORDER_BY_USERNAME_ASC 				= "U";
	public static final String ORDER_BY_USERNAME_DESC 				= "u";
	public static final String ORDER_BY_EMAIL_ASC 					= "Em";
	public static final String ORDER_BY_EMAIL_DESC 					= "em";
	public static final String ORDER_BY_CREATED_ASC 				= "C";
	public static final String ORDER_BY_CREATED_DESC 				= "c";
	public static final String ORDER_BY_ENABLED_ASC 				= "E";
	public static final String ORDER_BY_ENABLED_DESC 				= "e";
	public static final String ORDER_BY_GROUP_ASC					= "G";
	public static final String ORDER_BY_GROUP_DESC					= "g";
	
}
